
YZ_PATH = ('yzm', 'startYzm.exe')
DB_PATH = 'TiaoMa'
TABLE_NAME_CHANG_SHANG = 'CompanyName'
TABLE_NAME_INFO = 'CompanyInfo'

COMPANY_NAME_COL={'name':'sss','code':'sss','loginDate': 'DATE','logDate':'DATE','logoutFlag':0,'fid': 'sss','state':0,'isuse':0}

COMPANY_COL = {
    "_id": "697689262",
    "_score": 45.281265,
    "firm_name": "湖北省茹果人生食品有限公司",
    "f_id": 1224017,
    "firm_code": "",
    "logout_flag": "0",
    "leader": "赵恩德",
    "branch_code": "4201    ",
    "register_address1": "",
    "dm": "150",
    "register_postalcode": "441100",
    "contactman": "万红丽",
    "email": "2225676869@qq.com                                                                                   ",
    "used_num": "",
    "in_flag": "0",
    "code": "697689262",
    "register_address": "湖北省襄阳市枣阳市吴店镇清潭街道新华路80号(住所申报)",
    "political": "420607",
    "register_principal": 100,
    "net_station": "",
    "code_type": "1",
    "wishused_num": 1,
    "t_j_dm": "C1399",
    "leader_tele": "",
    "mp": "",
    "logout_date": "",
    "firm_name1": "",
    "firm_type": "1         ",
    "coin_type": "1         ",
    "_$Timestamp306": "",
    "dbd_code": "",
    "approve_man": "1694      ",
    "login_date": "2023-10-23T16:00:00.000Z",
    "address": "湖北省襄阳市枣阳市吴店镇清潭街道新华路80号(住所申报)",
    "address1": "",
    "postcode": "441100",
    "type": "anccfirm",
    "memo": "",
    "_$Version316": "",
    "fax": "",
    "leader_handset": "18903541292         ",
    "certificate_code": "91420683MACWRC8762                                ",
    "tele": "15671295063",
    "valid_date": "2025-10-23T16:00:00.000Z",
    "daochu":0,
    "isuse":0,
    "pon":0
}

FS_PRO_COL= {
    "bcGoodsPics": "",
    "goodsTypeName": "待定",
    "companyName": "佛山市汇庭粮油制品有限公司",
    "goodsId": 468731,
    "barCodeId": 427,
    "goodsCode": "0152",
    "barCode": "6959277701520",
    "qrCode": "",
    "goodsName": "待定",
    "goodsIntroduce": "",
    "goodsTypeId": 26,
    "goodsDescribe": "",
    "brandName": "待定",
    "marketDate": "",
    "retailPrice": 1.23,
    "productionPlace": "",
    "keyword": "",
    "salesWebsite": "",
    "qualityPeriod": "",
    "goodsMaterial": "",
    "isGreen": 1,
    "isProtect": 1,
    "isReccommend": 1,
    "isSelling": 1,
    "maxNum": 1.00,
    "colorName": "",
    "colorValue": "",
    "bcShape": "EAN13",
    "specName": "待定",
    "netContent": "待定",
    "positive": 1,
    "negative": 0,
    "indicator": 0,
    "bcReduction": "",
    "bcConfirmDate": "DATE",
    "createdBy": "13923121954",
    "creationDate": "DATE",
    "lastUpdatedBy": "",
    "lastUpdateDate": "DATETIME",
    "companyId": 212,
    "isAudit": 1,
    "auditDate": "DATE",
    "auditBy": "",
    "auditNotes": "",
    "attribute1": "",
    "attribute2": 0,
    "attribute3": "待定",
    "attribute4": "",
    "attribute5": "",
    "barCodeValue": "69592777",
    "state":0,
    "isuse":0
}

ZS_PRO_COL= {
    "bcGoodsPics": "",
    "goodsTypeName": "待定",
    "companyName": "佛山市汇庭粮油制品有限公司",
    "goodsId": 468731,
    "barCodeId": 427,
    "goodsCode": "0152",
    "barCode": "6959277701520",
    "qrCode": "",
    "goodsName": "待定",
    "goodsIntroduce": "",
    "goodsTypeId": 26,
    "goodsDescribe": "",
    "brandName": "待定",
    "marketDate": "",
    "retailPrice": 1.23,
    "productionPlace": "",
    "keyword": "",
    "salesWebsite": "",
    "qualityPeriod": "",
    "goodsMaterial": "",
    "isGreen": 1,
    "isProtect": 1,
    "isReccommend": 1,
    "isSelling": 1,
    "maxNum": 1.00,
    "colorName": "",
    "colorValue": "",
    "bcShape": "EAN13",
    "specName": "待定",
    "netContent": "待定",
    "positive": 1,
    "negative": 0,
    "indicator": 0,
    "bcReduction": "",
    "bcConfirmDate": "DATE",
    "createdBy": "13923121954",
    "creationDate": "DATE",
    "lastUpdatedBy": "",
    "lastUpdateDate": "DATETIME",
    "companyId": 212,
    "isAudit": 1,
    "auditDate": "DATE",
    "auditBy": "",
    "auditNotes": "",
    "attribute1": "",
    "attribute2": 0,
    "attribute3": "待定",
    "attribute4": "",
    "attribute5": "",
    "barCodeValue": "69592777",
    "state":0,
    "isuse":0
}

ZGSB_COL={       
    "_id": "1990591531578372096",
    "searchId": "1990591531578372096",
    "anncIssue": "1960",
    "anncDate": "DATE",
    "anncType": "TMXZSQ",
    "anncTypeName": "注册商标续展公告",
    "regNo": "846261",
    "regNoSort": "0000000000846261",
    "pageNo": 64,
    "validFlag": 1,
    "registerCnName": "泉州金山石材工具科技有限公司",
    "registerCnAddress": "福建省泉州市鲤城区南环路922号",
    "registerEnName": "",
    "registerEnAddress": "",
    "agentName": "",
    "tmName": "图形",
    "tmDescType": "0010",
    "tmSolidFlag": 0,
    "tmShareFlag": 0,
    "colorCombFlag": 0,
    "tmVoiceFlag": 0,
    "priorityFlag": 0,
    "tmType": "P",
    "applyDate": "DATE",
    "coownerList": "",
    "imgDir": "/group3/M00/4A/5D/CgoDIWkdo2OATWdXAAEPMN7O0io526.pdf",
    "fileId": "1990591531813253120",
    "intlCls": "3",
    "geoMarkInfo": "",
    "specialPeriodBeginDate": "DATE",
    "specialPeriodEndDate": "DATE",
    "anncPageNum": 5104,
    "pledgorName": "",
    "pledgeeName": "",
    "pledgeeBeginDate": "DATE",
    "pledgeeEndDate": "DATE",
    "pledgeeRegNo": 1,
    "agentId": "",
    "is_dc":0,
    "is_on":0     
}

ZGSB_QS_COL={
    'anncIssue': '1960',
    'page':1,
    'page_size':100,
    'max_page':2000,
    'state':0,
    'isuse':0
}